using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VITTERM
    {
        public DataRow Convert2ITTERM(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryITTERM(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["ITTTERMNR"] = " ".PadRight(8 ); 
         dwReturn["ITTAENDZL"] = " ".PadRight(0 ); 
         dwReturn["ITTAENDBEN"] = " ".PadRight(8 ); 
         dwReturn["ITTAENDDAT"] = " ".PadRight(0 ); 
         dwReturn["ITTNEUBEN"] = " ".PadRight(8 ); 
         dwReturn["ITTNEUDAT"] = " ".PadRight(0 ); 
         dwReturn["ITTSTATUS"] = " ".PadRight(1 ); 
         dwReturn["ITTLOCATION"] = " ".PadRight(50 ); 
         dwReturn["ITTREMARK"] = " ".PadRight(200 ); 
         dwReturn["ITTDS28"] = " ".PadRight(8 ); 
         dwReturn["ITTTIME"] = " ".PadRight(8 ); 
         dwReturn["ITTCOBENID1"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST1"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT1"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME1"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT1"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME1"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID1"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS1"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC1"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT1"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT1"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP1"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I41"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I41"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I21"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I21"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER1"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID2"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST2"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT2"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME2"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT2"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME2"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID2"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS2"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC2"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT2"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT2"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP2"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I42"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I42"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I22"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I22"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER2"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID3"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST3"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT3"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME3"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT3"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME3"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID3"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS3"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC3"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT3"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT3"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP3"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I43"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I43"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I23"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I23"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER3"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID4"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST4"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT4"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME4"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT4"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME4"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID4"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS4"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC4"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT4"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT4"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP4"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I44"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I44"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I24"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I24"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER4"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID5"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST5"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT5"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME5"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT5"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME5"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID5"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS5"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC5"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT5"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT5"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP5"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I45"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I45"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I25"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I25"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER5"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID6"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST6"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT6"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME6"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT6"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME6"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID6"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS6"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC6"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT6"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT6"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP6"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I46"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I46"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I26"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I26"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER6"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID7"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST7"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT7"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME7"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT7"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME7"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID7"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS7"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC7"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT7"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT7"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP7"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I47"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I47"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I27"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I27"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER7"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID8"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST8"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT8"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME8"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT8"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME8"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID8"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS8"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC8"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT8"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT8"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP8"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I48"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I48"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I28"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I28"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER8"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID9"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST9"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT9"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME9"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT9"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME9"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID9"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS9"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC9"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT9"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT9"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP9"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I49"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I49"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I29"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I29"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER9"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID10"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST10"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT10"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME10"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT10"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME10"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID10"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS10"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC10"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT10"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT10"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP10"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I410"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I410"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I210"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I210"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER10"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID11"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST11"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT11"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME11"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT11"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME11"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID11"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS11"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC11"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT11"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT11"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP11"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I411"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I411"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I211"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I211"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER11"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID12"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST12"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT12"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME12"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT12"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME12"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID12"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS12"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC12"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT12"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT12"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP12"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I412"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I412"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I212"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I212"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER12"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID13"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST13"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT13"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME13"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT13"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME13"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID13"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS13"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC13"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT13"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT13"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP13"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I413"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I413"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I213"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I213"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER13"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID14"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST14"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT14"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME14"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT14"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME14"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID14"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS14"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC14"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT14"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT14"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP14"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I414"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I414"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I214"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I214"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER14"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID15"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST15"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT15"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME15"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT15"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME15"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID15"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS15"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC15"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT15"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT15"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP15"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I415"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I415"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I215"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I215"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER15"] = " ".PadRight(20 ); 
         dwReturn["ITTCOBENID16"] = " ".PadRight(8 ); 
         dwReturn["ITTCOINST16"] = " ".PadRight(2 ); 
         dwReturn["ITTCOSDAT16"] = " ".PadRight(0 ); 
         dwReturn["ITTCOSTIME16"] = " ".PadRight(0 ); 
         dwReturn["ITTCOEDAT16"] = " ".PadRight(0 ); 
         dwReturn["ITTCOETIME16"] = " ".PadRight(0 ); 
         dwReturn["ITTCOPID16"] = " ".PadRight(0 ); 
         dwReturn["ITTCOIPS16"] = " ".PadRight(18 ); 
         dwReturn["ITTCOIPC16"] = " ".PadRight(18 ); 
         dwReturn["ITTCOLOGOUT16"] = " ".PadRight(1 ); 
         dwReturn["ITTCOMANDANT16"] = " ".PadRight(2 ); 
         dwReturn["ITTCOTYP16"] = " ".PadRight(1 ); 
         dwReturn["ITTCORES1I416"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I416"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES1I216"] = " ".PadRight(0 ); 
         dwReturn["ITTCORES2I216"] = " ".PadRight(0 ); 
         dwReturn["ITTCOFILLER16"] = " ".PadRight(20 ); 
         dwReturn["ITTCOUNTRY"] = " ".PadRight(3 ); 
         dwReturn["ITTTOWN"] = " ".PadRight(40 ); 
         dwReturn["ITTPHONE"] = " ".PadRight(20 ); 
         dwReturn["ITTCMDMAIL"] = " ".PadRight(80 ); 
         dwReturn["ITTCMDEXCEL"] = " ".PadRight(80 ); 
         dwReturn["ITTMAKRBEARB"] = " ".PadRight(1 ); 
         dwReturn["ITTMNRKRS"] = " ".PadRight(2 ); 
         dwReturn["ITTMLFDNR"] = " ".PadRight(4 ); 
         dwReturn["ITTMPOS"] = " ".PadRight(2 ); 
         dwReturn["ITTDOWNDATE"] = " ".PadRight(8 ); 
         dwReturn["ITTDOWNTIME"] = " ".PadRight(4 ); 
         dwReturn["ITTFILLER"] = " ".PadRight(687 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapITTERM(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveITTERM(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryITTERM(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapITTERM(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertITTERM(dwLocal, ITXDBVERSION);
            }
            UpdateITTERM(dwLocal);
        }
        public void InsertITTERM(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO ITTERM(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryITTERM(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM ITTERM WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM ITTERM  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "ITTERM";
            Return = Result;
            return Return;
        }
        public void DeleteITTERM(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ITTERM   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateITTERM(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE ITTERM SET "
                    +"ITTTERMNR= :ITTTERMNR,"
                    +"ITTAENDZL= :ITTAENDZL,"
                    +"ITTAENDBEN= :ITTAENDBEN,"
                    +"ITTAENDDAT= :ITTAENDDAT,"
                    +"ITTNEUBEN= :ITTNEUBEN,"
                    +"ITTNEUDAT= :ITTNEUDAT,"
                    +"ITTSTATUS= :ITTSTATUS,"
                    +"ITTLOCATION= :ITTLOCATION,"
                    +"ITTREMARK= :ITTREMARK,"
                    +"ITTDS28= :ITTDS28,"
                    +"ITTTIME= :ITTTIME,"
                    +"ITTCOBENID1= :ITTCOBENID1,"
                    +"ITTCOINST1= :ITTCOINST1,"
                    +"ITTCOSDAT1= :ITTCOSDAT1,"
                    +"ITTCOSTIME1= :ITTCOSTIME1,"
                    +"ITTCOEDAT1= :ITTCOEDAT1,"
                    +"ITTCOETIME1= :ITTCOETIME1,"
                    +"ITTCOPID1= :ITTCOPID1,"
                    +"ITTCOIPS1= :ITTCOIPS1,"
                    +"ITTCOIPC1= :ITTCOIPC1,"
                    +"ITTCOLOGOUT1= :ITTCOLOGOUT1,"
                    +"ITTCOMANDANT1= :ITTCOMANDANT1,"
                    +"ITTCOTYP1= :ITTCOTYP1,"
                    +"ITTCORES1I41= :ITTCORES1I41,"
                    +"ITTCORES2I41= :ITTCORES2I41,"
                    +"ITTCORES1I21= :ITTCORES1I21,"
                    +"ITTCORES2I21= :ITTCORES2I21,"
                    +"ITTCOFILLER1= :ITTCOFILLER1,"
                    +"ITTCOBENID2= :ITTCOBENID2,"
                    +"ITTCOINST2= :ITTCOINST2,"
                    +"ITTCOSDAT2= :ITTCOSDAT2,"
                    +"ITTCOSTIME2= :ITTCOSTIME2,"
                    +"ITTCOEDAT2= :ITTCOEDAT2,"
                    +"ITTCOETIME2= :ITTCOETIME2,"
                    +"ITTCOPID2= :ITTCOPID2,"
                    +"ITTCOIPS2= :ITTCOIPS2,"
                    +"ITTCOIPC2= :ITTCOIPC2,"
                    +"ITTCOLOGOUT2= :ITTCOLOGOUT2,"
                    +"ITTCOMANDANT2= :ITTCOMANDANT2,"
                    +"ITTCOTYP2= :ITTCOTYP2,"
                    +"ITTCORES1I42= :ITTCORES1I42,"
                    +"ITTCORES2I42= :ITTCORES2I42,"
                    +"ITTCORES1I22= :ITTCORES1I22,"
                    +"ITTCORES2I22= :ITTCORES2I22,"
                    +"ITTCOFILLER2= :ITTCOFILLER2,"
                    +"ITTCOBENID3= :ITTCOBENID3,"
                    +"ITTCOINST3= :ITTCOINST3,"
                    +"ITTCOSDAT3= :ITTCOSDAT3,"
                    +"ITTCOSTIME3= :ITTCOSTIME3,"
                    +"ITTCOEDAT3= :ITTCOEDAT3,"
                    +"ITTCOETIME3= :ITTCOETIME3,"
                    +"ITTCOPID3= :ITTCOPID3,"
                    +"ITTCOIPS3= :ITTCOIPS3,"
                    +"ITTCOIPC3= :ITTCOIPC3,"
                    +"ITTCOLOGOUT3= :ITTCOLOGOUT3,"
                    +"ITTCOMANDANT3= :ITTCOMANDANT3,"
                    +"ITTCOTYP3= :ITTCOTYP3,"
                    +"ITTCORES1I43= :ITTCORES1I43,"
                    +"ITTCORES2I43= :ITTCORES2I43,"
                    +"ITTCORES1I23= :ITTCORES1I23,"
                    +"ITTCORES2I23= :ITTCORES2I23,"
                    +"ITTCOFILLER3= :ITTCOFILLER3,"
                    +"ITTCOBENID4= :ITTCOBENID4,"
                    +"ITTCOINST4= :ITTCOINST4,"
                    +"ITTCOSDAT4= :ITTCOSDAT4,"
                    +"ITTCOSTIME4= :ITTCOSTIME4,"
                    +"ITTCOEDAT4= :ITTCOEDAT4,"
                    +"ITTCOETIME4= :ITTCOETIME4,"
                    +"ITTCOPID4= :ITTCOPID4,"
                    +"ITTCOIPS4= :ITTCOIPS4,"
                    +"ITTCOIPC4= :ITTCOIPC4,"
                    +"ITTCOLOGOUT4= :ITTCOLOGOUT4,"
                    +"ITTCOMANDANT4= :ITTCOMANDANT4,"
                    +"ITTCOTYP4= :ITTCOTYP4,"
                    +"ITTCORES1I44= :ITTCORES1I44,"
                    +"ITTCORES2I44= :ITTCORES2I44,"
                    +"ITTCORES1I24= :ITTCORES1I24,"
                    +"ITTCORES2I24= :ITTCORES2I24,"
                    +"ITTCOFILLER4= :ITTCOFILLER4,"
                    +"ITTCOBENID5= :ITTCOBENID5,"
                    +"ITTCOINST5= :ITTCOINST5,"
                    +"ITTCOSDAT5= :ITTCOSDAT5,"
                    +"ITTCOSTIME5= :ITTCOSTIME5,"
                    +"ITTCOEDAT5= :ITTCOEDAT5,"
                    +"ITTCOETIME5= :ITTCOETIME5,"
                    +"ITTCOPID5= :ITTCOPID5,"
                    +"ITTCOIPS5= :ITTCOIPS5,"
                    +"ITTCOIPC5= :ITTCOIPC5,"
                    +"ITTCOLOGOUT5= :ITTCOLOGOUT5,"
                    +"ITTCOMANDANT5= :ITTCOMANDANT5,"
                    +"ITTCOTYP5= :ITTCOTYP5,"
                    +"ITTCORES1I45= :ITTCORES1I45,"
                    +"ITTCORES2I45= :ITTCORES2I45,"
                    +"ITTCORES1I25= :ITTCORES1I25,"
                    +"ITTCORES2I25= :ITTCORES2I25,"
                    +"ITTCOFILLER5= :ITTCOFILLER5,"
                    +"ITTCOBENID6= :ITTCOBENID6,"
                    +"ITTCOINST6= :ITTCOINST6,"
                    +"ITTCOSDAT6= :ITTCOSDAT6,"
                    +"ITTCOSTIME6= :ITTCOSTIME6,"
                    +"ITTCOEDAT6= :ITTCOEDAT6,"
                    +"ITTCOETIME6= :ITTCOETIME6,"
                    +"ITTCOPID6= :ITTCOPID6,"
                    +"ITTCOIPS6= :ITTCOIPS6,"
                    +"ITTCOIPC6= :ITTCOIPC6,"
                    +"ITTCOLOGOUT6= :ITTCOLOGOUT6,"
                    +"ITTCOMANDANT6= :ITTCOMANDANT6,"
                    +"ITTCOTYP6= :ITTCOTYP6,"
                    +"ITTCORES1I46= :ITTCORES1I46,"
                    +"ITTCORES2I46= :ITTCORES2I46,"
                    +"ITTCORES1I26= :ITTCORES1I26,"
                    +"ITTCORES2I26= :ITTCORES2I26,"
                    +"ITTCOFILLER6= :ITTCOFILLER6,"
                    +"ITTCOBENID7= :ITTCOBENID7,"
                    +"ITTCOINST7= :ITTCOINST7,"
                    +"ITTCOSDAT7= :ITTCOSDAT7,"
                    +"ITTCOSTIME7= :ITTCOSTIME7,"
                    +"ITTCOEDAT7= :ITTCOEDAT7,"
                    +"ITTCOETIME7= :ITTCOETIME7,"
                    +"ITTCOPID7= :ITTCOPID7,"
                    +"ITTCOIPS7= :ITTCOIPS7,"
                    +"ITTCOIPC7= :ITTCOIPC7,"
                    +"ITTCOLOGOUT7= :ITTCOLOGOUT7,"
                    +"ITTCOMANDANT7= :ITTCOMANDANT7,"
                    +"ITTCOTYP7= :ITTCOTYP7,"
                    +"ITTCORES1I47= :ITTCORES1I47,"
                    +"ITTCORES2I47= :ITTCORES2I47,"
                    +"ITTCORES1I27= :ITTCORES1I27,"
                    +"ITTCORES2I27= :ITTCORES2I27,"
                    +"ITTCOFILLER7= :ITTCOFILLER7,"
                    +"ITTCOBENID8= :ITTCOBENID8,"
                    +"ITTCOINST8= :ITTCOINST8,"
                    +"ITTCOSDAT8= :ITTCOSDAT8,"
                    +"ITTCOSTIME8= :ITTCOSTIME8,"
                    +"ITTCOEDAT8= :ITTCOEDAT8,"
                    +"ITTCOETIME8= :ITTCOETIME8,"
                    +"ITTCOPID8= :ITTCOPID8,"
                    +"ITTCOIPS8= :ITTCOIPS8,"
                    +"ITTCOIPC8= :ITTCOIPC8,"
                    +"ITTCOLOGOUT8= :ITTCOLOGOUT8,"
                    +"ITTCOMANDANT8= :ITTCOMANDANT8,"
                    +"ITTCOTYP8= :ITTCOTYP8,"
                    +"ITTCORES1I48= :ITTCORES1I48,"
                    +"ITTCORES2I48= :ITTCORES2I48,"
                    +"ITTCORES1I28= :ITTCORES1I28,"
                    +"ITTCORES2I28= :ITTCORES2I28,"
                    +"ITTCOFILLER8= :ITTCOFILLER8,"
                    +"ITTCOBENID9= :ITTCOBENID9,"
                    +"ITTCOINST9= :ITTCOINST9,"
                    +"ITTCOSDAT9= :ITTCOSDAT9,"
                    +"ITTCOSTIME9= :ITTCOSTIME9,"
                    +"ITTCOEDAT9= :ITTCOEDAT9,"
                    +"ITTCOETIME9= :ITTCOETIME9,"
                    +"ITTCOPID9= :ITTCOPID9,"
                    +"ITTCOIPS9= :ITTCOIPS9,"
                    +"ITTCOIPC9= :ITTCOIPC9,"
                    +"ITTCOLOGOUT9= :ITTCOLOGOUT9,"
                    +"ITTCOMANDANT9= :ITTCOMANDANT9,"
                    +"ITTCOTYP9= :ITTCOTYP9,"
                    +"ITTCORES1I49= :ITTCORES1I49,"
                    +"ITTCORES2I49= :ITTCORES2I49,"
                    +"ITTCORES1I29= :ITTCORES1I29,"
                    +"ITTCORES2I29= :ITTCORES2I29,"
                    +"ITTCOFILLER9= :ITTCOFILLER9,"
                    +"ITTCOBENID10= :ITTCOBENID10,"
                    +"ITTCOINST10= :ITTCOINST10,"
                    +"ITTCOSDAT10= :ITTCOSDAT10,"
                    +"ITTCOSTIME10= :ITTCOSTIME10,"
                    +"ITTCOEDAT10= :ITTCOEDAT10,"
                    +"ITTCOETIME10= :ITTCOETIME10,"
                    +"ITTCOPID10= :ITTCOPID10,"
                    +"ITTCOIPS10= :ITTCOIPS10,"
                    +"ITTCOIPC10= :ITTCOIPC10,"
                    +"ITTCOLOGOUT10= :ITTCOLOGOUT10,"
                    +"ITTCOMANDANT10= :ITTCOMANDANT10,"
                    +"ITTCOTYP10= :ITTCOTYP10,"
                    +"ITTCORES1I410= :ITTCORES1I410,"
                    +"ITTCORES2I410= :ITTCORES2I410,"
                    +"ITTCORES1I210= :ITTCORES1I210,"
                    +"ITTCORES2I210= :ITTCORES2I210,"
                    +"ITTCOFILLER10= :ITTCOFILLER10,"
                    +"ITTCOBENID11= :ITTCOBENID11,"
                    +"ITTCOINST11= :ITTCOINST11,"
                    +"ITTCOSDAT11= :ITTCOSDAT11,"
                    +"ITTCOSTIME11= :ITTCOSTIME11,"
                    +"ITTCOEDAT11= :ITTCOEDAT11,"
                    +"ITTCOETIME11= :ITTCOETIME11,"
                    +"ITTCOPID11= :ITTCOPID11,"
                    +"ITTCOIPS11= :ITTCOIPS11,"
                    +"ITTCOIPC11= :ITTCOIPC11,"
                    +"ITTCOLOGOUT11= :ITTCOLOGOUT11,"
                    +"ITTCOMANDANT11= :ITTCOMANDANT11,"
                    +"ITTCOTYP11= :ITTCOTYP11,"
                    +"ITTCORES1I411= :ITTCORES1I411,"
                    +"ITTCORES2I411= :ITTCORES2I411,"
                    +"ITTCORES1I211= :ITTCORES1I211,"
                    +"ITTCORES2I211= :ITTCORES2I211,"
                    +"ITTCOFILLER11= :ITTCOFILLER11,"
                    +"ITTCOBENID12= :ITTCOBENID12,"
                    +"ITTCOINST12= :ITTCOINST12,"
                    +"ITTCOSDAT12= :ITTCOSDAT12,"
                    +"ITTCOSTIME12= :ITTCOSTIME12,"
                    +"ITTCOEDAT12= :ITTCOEDAT12,"
                    +"ITTCOETIME12= :ITTCOETIME12,"
                    +"ITTCOPID12= :ITTCOPID12,"
                    +"ITTCOIPS12= :ITTCOIPS12,"
                    +"ITTCOIPC12= :ITTCOIPC12,"
                    +"ITTCOLOGOUT12= :ITTCOLOGOUT12,"
                    +"ITTCOMANDANT12= :ITTCOMANDANT12,"
                    +"ITTCOTYP12= :ITTCOTYP12,"
                    +"ITTCORES1I412= :ITTCORES1I412,"
                    +"ITTCORES2I412= :ITTCORES2I412,"
                    +"ITTCORES1I212= :ITTCORES1I212,"
                    +"ITTCORES2I212= :ITTCORES2I212,"
                    +"ITTCOFILLER12= :ITTCOFILLER12,"
                    +"ITTCOBENID13= :ITTCOBENID13,"
                    +"ITTCOINST13= :ITTCOINST13,"
                    +"ITTCOSDAT13= :ITTCOSDAT13,"
                    +"ITTCOSTIME13= :ITTCOSTIME13,"
                    +"ITTCOEDAT13= :ITTCOEDAT13,"
                    +"ITTCOETIME13= :ITTCOETIME13,"
                    +"ITTCOPID13= :ITTCOPID13,"
                    +"ITTCOIPS13= :ITTCOIPS13,"
                    +"ITTCOIPC13= :ITTCOIPC13,"
                    +"ITTCOLOGOUT13= :ITTCOLOGOUT13,"
                    +"ITTCOMANDANT13= :ITTCOMANDANT13,"
                    +"ITTCOTYP13= :ITTCOTYP13,"
                    +"ITTCORES1I413= :ITTCORES1I413,"
                    +"ITTCORES2I413= :ITTCORES2I413,"
                    +"ITTCORES1I213= :ITTCORES1I213,"
                    +"ITTCORES2I213= :ITTCORES2I213,"
                    +"ITTCOFILLER13= :ITTCOFILLER13,"
                    +"ITTCOBENID14= :ITTCOBENID14,"
                    +"ITTCOINST14= :ITTCOINST14,"
                    +"ITTCOSDAT14= :ITTCOSDAT14,"
                    +"ITTCOSTIME14= :ITTCOSTIME14,"
                    +"ITTCOEDAT14= :ITTCOEDAT14,"
                    +"ITTCOETIME14= :ITTCOETIME14,"
                    +"ITTCOPID14= :ITTCOPID14,"
                    +"ITTCOIPS14= :ITTCOIPS14,"
                    +"ITTCOIPC14= :ITTCOIPC14,"
                    +"ITTCOLOGOUT14= :ITTCOLOGOUT14,"
                    +"ITTCOMANDANT14= :ITTCOMANDANT14,"
                    +"ITTCOTYP14= :ITTCOTYP14,"
                    +"ITTCORES1I414= :ITTCORES1I414,"
                    +"ITTCORES2I414= :ITTCORES2I414,"
                    +"ITTCORES1I214= :ITTCORES1I214,"
                    +"ITTCORES2I214= :ITTCORES2I214,"
                    +"ITTCOFILLER14= :ITTCOFILLER14,"
                    +"ITTCOBENID15= :ITTCOBENID15,"
                    +"ITTCOINST15= :ITTCOINST15,"
                    +"ITTCOSDAT15= :ITTCOSDAT15,"
                    +"ITTCOSTIME15= :ITTCOSTIME15,"
                    +"ITTCOEDAT15= :ITTCOEDAT15,"
                    +"ITTCOETIME15= :ITTCOETIME15,"
                    +"ITTCOPID15= :ITTCOPID15,"
                    +"ITTCOIPS15= :ITTCOIPS15,"
                    +"ITTCOIPC15= :ITTCOIPC15,"
                    +"ITTCOLOGOUT15= :ITTCOLOGOUT15,"
                    +"ITTCOMANDANT15= :ITTCOMANDANT15,"
                    +"ITTCOTYP15= :ITTCOTYP15,"
                    +"ITTCORES1I415= :ITTCORES1I415,"
                    +"ITTCORES2I415= :ITTCORES2I415,"
                    +"ITTCORES1I215= :ITTCORES1I215,"
                    +"ITTCORES2I215= :ITTCORES2I215,"
                    +"ITTCOFILLER15= :ITTCOFILLER15,"
                    +"ITTCOBENID16= :ITTCOBENID16,"
                    +"ITTCOINST16= :ITTCOINST16,"
                    +"ITTCOSDAT16= :ITTCOSDAT16,"
                    +"ITTCOSTIME16= :ITTCOSTIME16,"
                    +"ITTCOEDAT16= :ITTCOEDAT16,"
                    +"ITTCOETIME16= :ITTCOETIME16,"
                    +"ITTCOPID16= :ITTCOPID16,"
                    +"ITTCOIPS16= :ITTCOIPS16,"
                    +"ITTCOIPC16= :ITTCOIPC16,"
                    +"ITTCOLOGOUT16= :ITTCOLOGOUT16,"
                    +"ITTCOMANDANT16= :ITTCOMANDANT16,"
                    +"ITTCOTYP16= :ITTCOTYP16,"
                    +"ITTCORES1I416= :ITTCORES1I416,"
                    +"ITTCORES2I416= :ITTCORES2I416,"
                    +"ITTCORES1I216= :ITTCORES1I216,"
                    +"ITTCORES2I216= :ITTCORES2I216,"
                    +"ITTCOFILLER16= :ITTCOFILLER16,"
                    +"ITTCOUNTRY= :ITTCOUNTRY,"
                    +"ITTTOWN= :ITTTOWN,"
                    +"ITTPHONE= :ITTPHONE,"
                    +"ITTCMDMAIL= :ITTCMDMAIL,"
                    +"ITTCMDEXCEL= :ITTCMDEXCEL,"
                    +"ITTMAKRBEARB= :ITTMAKRBEARB,"
                    +"ITTMNRKRS= :ITTMNRKRS,"
                    +"ITTMLFDNR= :ITTMLFDNR,"
                    +"ITTMPOS= :ITTMPOS,"
                    +"ITTDOWNDATE= :ITTDOWNDATE,"
                    +"ITTDOWNTIME= :ITTDOWNTIME,"
                    +"ITTFILLER= :ITTFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("ITTTERMNR", OracleType.NVarChar).Value = dwData["ITTTERMNR"].ToString(); 
          or1.Parameters.Add("ITTAENDZL", OracleType.NVarChar).Value = dwData["ITTAENDZL"].ToString(); 
          or1.Parameters.Add("ITTAENDBEN", OracleType.NVarChar).Value = dwData["ITTAENDBEN"].ToString(); 
          or1.Parameters.Add("ITTAENDDAT", OracleType.NVarChar).Value = dwData["ITTAENDDAT"].ToString(); 
          or1.Parameters.Add("ITTNEUBEN", OracleType.NVarChar).Value = dwData["ITTNEUBEN"].ToString(); 
          or1.Parameters.Add("ITTNEUDAT", OracleType.NVarChar).Value = dwData["ITTNEUDAT"].ToString(); 
          or1.Parameters.Add("ITTSTATUS", OracleType.NVarChar).Value = dwData["ITTSTATUS"].ToString(); 
          or1.Parameters.Add("ITTLOCATION", OracleType.NVarChar).Value = dwData["ITTLOCATION"].ToString(); 
          or1.Parameters.Add("ITTREMARK", OracleType.NVarChar).Value = dwData["ITTREMARK"].ToString(); 
          or1.Parameters.Add("ITTDS28", OracleType.NVarChar).Value = dwData["ITTDS28"].ToString(); 
          or1.Parameters.Add("ITTTIME", OracleType.NVarChar).Value = dwData["ITTTIME"].ToString(); 
          or1.Parameters.Add("ITTCOBENID1", OracleType.NVarChar).Value = dwData["ITTCOBENID1"].ToString(); 
          or1.Parameters.Add("ITTCOINST1", OracleType.NVarChar).Value = dwData["ITTCOINST1"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT1", OracleType.NVarChar).Value = dwData["ITTCOSDAT1"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME1", OracleType.NVarChar).Value = dwData["ITTCOSTIME1"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT1", OracleType.NVarChar).Value = dwData["ITTCOEDAT1"].ToString(); 
          or1.Parameters.Add("ITTCOETIME1", OracleType.NVarChar).Value = dwData["ITTCOETIME1"].ToString(); 
          or1.Parameters.Add("ITTCOPID1", OracleType.NVarChar).Value = dwData["ITTCOPID1"].ToString(); 
          or1.Parameters.Add("ITTCOIPS1", OracleType.NVarChar).Value = dwData["ITTCOIPS1"].ToString(); 
          or1.Parameters.Add("ITTCOIPC1", OracleType.NVarChar).Value = dwData["ITTCOIPC1"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT1", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT1"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT1", OracleType.NVarChar).Value = dwData["ITTCOMANDANT1"].ToString(); 
          or1.Parameters.Add("ITTCOTYP1", OracleType.NVarChar).Value = dwData["ITTCOTYP1"].ToString(); 
          or1.Parameters.Add("ITTCORES1I41", OracleType.NVarChar).Value = dwData["ITTCORES1I41"].ToString(); 
          or1.Parameters.Add("ITTCORES2I41", OracleType.NVarChar).Value = dwData["ITTCORES2I41"].ToString(); 
          or1.Parameters.Add("ITTCORES1I21", OracleType.NVarChar).Value = dwData["ITTCORES1I21"].ToString(); 
          or1.Parameters.Add("ITTCORES2I21", OracleType.NVarChar).Value = dwData["ITTCORES2I21"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER1", OracleType.NVarChar).Value = dwData["ITTCOFILLER1"].ToString(); 
          or1.Parameters.Add("ITTCOBENID2", OracleType.NVarChar).Value = dwData["ITTCOBENID2"].ToString(); 
          or1.Parameters.Add("ITTCOINST2", OracleType.NVarChar).Value = dwData["ITTCOINST2"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT2", OracleType.NVarChar).Value = dwData["ITTCOSDAT2"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME2", OracleType.NVarChar).Value = dwData["ITTCOSTIME2"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT2", OracleType.NVarChar).Value = dwData["ITTCOEDAT2"].ToString(); 
          or1.Parameters.Add("ITTCOETIME2", OracleType.NVarChar).Value = dwData["ITTCOETIME2"].ToString(); 
          or1.Parameters.Add("ITTCOPID2", OracleType.NVarChar).Value = dwData["ITTCOPID2"].ToString(); 
          or1.Parameters.Add("ITTCOIPS2", OracleType.NVarChar).Value = dwData["ITTCOIPS2"].ToString(); 
          or1.Parameters.Add("ITTCOIPC2", OracleType.NVarChar).Value = dwData["ITTCOIPC2"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT2", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT2"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT2", OracleType.NVarChar).Value = dwData["ITTCOMANDANT2"].ToString(); 
          or1.Parameters.Add("ITTCOTYP2", OracleType.NVarChar).Value = dwData["ITTCOTYP2"].ToString(); 
          or1.Parameters.Add("ITTCORES1I42", OracleType.NVarChar).Value = dwData["ITTCORES1I42"].ToString(); 
          or1.Parameters.Add("ITTCORES2I42", OracleType.NVarChar).Value = dwData["ITTCORES2I42"].ToString(); 
          or1.Parameters.Add("ITTCORES1I22", OracleType.NVarChar).Value = dwData["ITTCORES1I22"].ToString(); 
          or1.Parameters.Add("ITTCORES2I22", OracleType.NVarChar).Value = dwData["ITTCORES2I22"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER2", OracleType.NVarChar).Value = dwData["ITTCOFILLER2"].ToString(); 
          or1.Parameters.Add("ITTCOBENID3", OracleType.NVarChar).Value = dwData["ITTCOBENID3"].ToString(); 
          or1.Parameters.Add("ITTCOINST3", OracleType.NVarChar).Value = dwData["ITTCOINST3"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT3", OracleType.NVarChar).Value = dwData["ITTCOSDAT3"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME3", OracleType.NVarChar).Value = dwData["ITTCOSTIME3"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT3", OracleType.NVarChar).Value = dwData["ITTCOEDAT3"].ToString(); 
          or1.Parameters.Add("ITTCOETIME3", OracleType.NVarChar).Value = dwData["ITTCOETIME3"].ToString(); 
          or1.Parameters.Add("ITTCOPID3", OracleType.NVarChar).Value = dwData["ITTCOPID3"].ToString(); 
          or1.Parameters.Add("ITTCOIPS3", OracleType.NVarChar).Value = dwData["ITTCOIPS3"].ToString(); 
          or1.Parameters.Add("ITTCOIPC3", OracleType.NVarChar).Value = dwData["ITTCOIPC3"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT3", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT3"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT3", OracleType.NVarChar).Value = dwData["ITTCOMANDANT3"].ToString(); 
          or1.Parameters.Add("ITTCOTYP3", OracleType.NVarChar).Value = dwData["ITTCOTYP3"].ToString(); 
          or1.Parameters.Add("ITTCORES1I43", OracleType.NVarChar).Value = dwData["ITTCORES1I43"].ToString(); 
          or1.Parameters.Add("ITTCORES2I43", OracleType.NVarChar).Value = dwData["ITTCORES2I43"].ToString(); 
          or1.Parameters.Add("ITTCORES1I23", OracleType.NVarChar).Value = dwData["ITTCORES1I23"].ToString(); 
          or1.Parameters.Add("ITTCORES2I23", OracleType.NVarChar).Value = dwData["ITTCORES2I23"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER3", OracleType.NVarChar).Value = dwData["ITTCOFILLER3"].ToString(); 
          or1.Parameters.Add("ITTCOBENID4", OracleType.NVarChar).Value = dwData["ITTCOBENID4"].ToString(); 
          or1.Parameters.Add("ITTCOINST4", OracleType.NVarChar).Value = dwData["ITTCOINST4"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT4", OracleType.NVarChar).Value = dwData["ITTCOSDAT4"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME4", OracleType.NVarChar).Value = dwData["ITTCOSTIME4"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT4", OracleType.NVarChar).Value = dwData["ITTCOEDAT4"].ToString(); 
          or1.Parameters.Add("ITTCOETIME4", OracleType.NVarChar).Value = dwData["ITTCOETIME4"].ToString(); 
          or1.Parameters.Add("ITTCOPID4", OracleType.NVarChar).Value = dwData["ITTCOPID4"].ToString(); 
          or1.Parameters.Add("ITTCOIPS4", OracleType.NVarChar).Value = dwData["ITTCOIPS4"].ToString(); 
          or1.Parameters.Add("ITTCOIPC4", OracleType.NVarChar).Value = dwData["ITTCOIPC4"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT4", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT4"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT4", OracleType.NVarChar).Value = dwData["ITTCOMANDANT4"].ToString(); 
          or1.Parameters.Add("ITTCOTYP4", OracleType.NVarChar).Value = dwData["ITTCOTYP4"].ToString(); 
          or1.Parameters.Add("ITTCORES1I44", OracleType.NVarChar).Value = dwData["ITTCORES1I44"].ToString(); 
          or1.Parameters.Add("ITTCORES2I44", OracleType.NVarChar).Value = dwData["ITTCORES2I44"].ToString(); 
          or1.Parameters.Add("ITTCORES1I24", OracleType.NVarChar).Value = dwData["ITTCORES1I24"].ToString(); 
          or1.Parameters.Add("ITTCORES2I24", OracleType.NVarChar).Value = dwData["ITTCORES2I24"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER4", OracleType.NVarChar).Value = dwData["ITTCOFILLER4"].ToString(); 
          or1.Parameters.Add("ITTCOBENID5", OracleType.NVarChar).Value = dwData["ITTCOBENID5"].ToString(); 
          or1.Parameters.Add("ITTCOINST5", OracleType.NVarChar).Value = dwData["ITTCOINST5"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT5", OracleType.NVarChar).Value = dwData["ITTCOSDAT5"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME5", OracleType.NVarChar).Value = dwData["ITTCOSTIME5"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT5", OracleType.NVarChar).Value = dwData["ITTCOEDAT5"].ToString(); 
          or1.Parameters.Add("ITTCOETIME5", OracleType.NVarChar).Value = dwData["ITTCOETIME5"].ToString(); 
          or1.Parameters.Add("ITTCOPID5", OracleType.NVarChar).Value = dwData["ITTCOPID5"].ToString(); 
          or1.Parameters.Add("ITTCOIPS5", OracleType.NVarChar).Value = dwData["ITTCOIPS5"].ToString(); 
          or1.Parameters.Add("ITTCOIPC5", OracleType.NVarChar).Value = dwData["ITTCOIPC5"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT5", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT5"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT5", OracleType.NVarChar).Value = dwData["ITTCOMANDANT5"].ToString(); 
          or1.Parameters.Add("ITTCOTYP5", OracleType.NVarChar).Value = dwData["ITTCOTYP5"].ToString(); 
          or1.Parameters.Add("ITTCORES1I45", OracleType.NVarChar).Value = dwData["ITTCORES1I45"].ToString(); 
          or1.Parameters.Add("ITTCORES2I45", OracleType.NVarChar).Value = dwData["ITTCORES2I45"].ToString(); 
          or1.Parameters.Add("ITTCORES1I25", OracleType.NVarChar).Value = dwData["ITTCORES1I25"].ToString(); 
          or1.Parameters.Add("ITTCORES2I25", OracleType.NVarChar).Value = dwData["ITTCORES2I25"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER5", OracleType.NVarChar).Value = dwData["ITTCOFILLER5"].ToString(); 
          or1.Parameters.Add("ITTCOBENID6", OracleType.NVarChar).Value = dwData["ITTCOBENID6"].ToString(); 
          or1.Parameters.Add("ITTCOINST6", OracleType.NVarChar).Value = dwData["ITTCOINST6"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT6", OracleType.NVarChar).Value = dwData["ITTCOSDAT6"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME6", OracleType.NVarChar).Value = dwData["ITTCOSTIME6"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT6", OracleType.NVarChar).Value = dwData["ITTCOEDAT6"].ToString(); 
          or1.Parameters.Add("ITTCOETIME6", OracleType.NVarChar).Value = dwData["ITTCOETIME6"].ToString(); 
          or1.Parameters.Add("ITTCOPID6", OracleType.NVarChar).Value = dwData["ITTCOPID6"].ToString(); 
          or1.Parameters.Add("ITTCOIPS6", OracleType.NVarChar).Value = dwData["ITTCOIPS6"].ToString(); 
          or1.Parameters.Add("ITTCOIPC6", OracleType.NVarChar).Value = dwData["ITTCOIPC6"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT6", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT6"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT6", OracleType.NVarChar).Value = dwData["ITTCOMANDANT6"].ToString(); 
          or1.Parameters.Add("ITTCOTYP6", OracleType.NVarChar).Value = dwData["ITTCOTYP6"].ToString(); 
          or1.Parameters.Add("ITTCORES1I46", OracleType.NVarChar).Value = dwData["ITTCORES1I46"].ToString(); 
          or1.Parameters.Add("ITTCORES2I46", OracleType.NVarChar).Value = dwData["ITTCORES2I46"].ToString(); 
          or1.Parameters.Add("ITTCORES1I26", OracleType.NVarChar).Value = dwData["ITTCORES1I26"].ToString(); 
          or1.Parameters.Add("ITTCORES2I26", OracleType.NVarChar).Value = dwData["ITTCORES2I26"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER6", OracleType.NVarChar).Value = dwData["ITTCOFILLER6"].ToString(); 
          or1.Parameters.Add("ITTCOBENID7", OracleType.NVarChar).Value = dwData["ITTCOBENID7"].ToString(); 
          or1.Parameters.Add("ITTCOINST7", OracleType.NVarChar).Value = dwData["ITTCOINST7"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT7", OracleType.NVarChar).Value = dwData["ITTCOSDAT7"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME7", OracleType.NVarChar).Value = dwData["ITTCOSTIME7"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT7", OracleType.NVarChar).Value = dwData["ITTCOEDAT7"].ToString(); 
          or1.Parameters.Add("ITTCOETIME7", OracleType.NVarChar).Value = dwData["ITTCOETIME7"].ToString(); 
          or1.Parameters.Add("ITTCOPID7", OracleType.NVarChar).Value = dwData["ITTCOPID7"].ToString(); 
          or1.Parameters.Add("ITTCOIPS7", OracleType.NVarChar).Value = dwData["ITTCOIPS7"].ToString(); 
          or1.Parameters.Add("ITTCOIPC7", OracleType.NVarChar).Value = dwData["ITTCOIPC7"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT7", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT7"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT7", OracleType.NVarChar).Value = dwData["ITTCOMANDANT7"].ToString(); 
          or1.Parameters.Add("ITTCOTYP7", OracleType.NVarChar).Value = dwData["ITTCOTYP7"].ToString(); 
          or1.Parameters.Add("ITTCORES1I47", OracleType.NVarChar).Value = dwData["ITTCORES1I47"].ToString(); 
          or1.Parameters.Add("ITTCORES2I47", OracleType.NVarChar).Value = dwData["ITTCORES2I47"].ToString(); 
          or1.Parameters.Add("ITTCORES1I27", OracleType.NVarChar).Value = dwData["ITTCORES1I27"].ToString(); 
          or1.Parameters.Add("ITTCORES2I27", OracleType.NVarChar).Value = dwData["ITTCORES2I27"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER7", OracleType.NVarChar).Value = dwData["ITTCOFILLER7"].ToString(); 
          or1.Parameters.Add("ITTCOBENID8", OracleType.NVarChar).Value = dwData["ITTCOBENID8"].ToString(); 
          or1.Parameters.Add("ITTCOINST8", OracleType.NVarChar).Value = dwData["ITTCOINST8"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT8", OracleType.NVarChar).Value = dwData["ITTCOSDAT8"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME8", OracleType.NVarChar).Value = dwData["ITTCOSTIME8"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT8", OracleType.NVarChar).Value = dwData["ITTCOEDAT8"].ToString(); 
          or1.Parameters.Add("ITTCOETIME8", OracleType.NVarChar).Value = dwData["ITTCOETIME8"].ToString(); 
          or1.Parameters.Add("ITTCOPID8", OracleType.NVarChar).Value = dwData["ITTCOPID8"].ToString(); 
          or1.Parameters.Add("ITTCOIPS8", OracleType.NVarChar).Value = dwData["ITTCOIPS8"].ToString(); 
          or1.Parameters.Add("ITTCOIPC8", OracleType.NVarChar).Value = dwData["ITTCOIPC8"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT8", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT8"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT8", OracleType.NVarChar).Value = dwData["ITTCOMANDANT8"].ToString(); 
          or1.Parameters.Add("ITTCOTYP8", OracleType.NVarChar).Value = dwData["ITTCOTYP8"].ToString(); 
          or1.Parameters.Add("ITTCORES1I48", OracleType.NVarChar).Value = dwData["ITTCORES1I48"].ToString(); 
          or1.Parameters.Add("ITTCORES2I48", OracleType.NVarChar).Value = dwData["ITTCORES2I48"].ToString(); 
          or1.Parameters.Add("ITTCORES1I28", OracleType.NVarChar).Value = dwData["ITTCORES1I28"].ToString(); 
          or1.Parameters.Add("ITTCORES2I28", OracleType.NVarChar).Value = dwData["ITTCORES2I28"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER8", OracleType.NVarChar).Value = dwData["ITTCOFILLER8"].ToString(); 
          or1.Parameters.Add("ITTCOBENID9", OracleType.NVarChar).Value = dwData["ITTCOBENID9"].ToString(); 
          or1.Parameters.Add("ITTCOINST9", OracleType.NVarChar).Value = dwData["ITTCOINST9"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT9", OracleType.NVarChar).Value = dwData["ITTCOSDAT9"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME9", OracleType.NVarChar).Value = dwData["ITTCOSTIME9"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT9", OracleType.NVarChar).Value = dwData["ITTCOEDAT9"].ToString(); 
          or1.Parameters.Add("ITTCOETIME9", OracleType.NVarChar).Value = dwData["ITTCOETIME9"].ToString(); 
          or1.Parameters.Add("ITTCOPID9", OracleType.NVarChar).Value = dwData["ITTCOPID9"].ToString(); 
          or1.Parameters.Add("ITTCOIPS9", OracleType.NVarChar).Value = dwData["ITTCOIPS9"].ToString(); 
          or1.Parameters.Add("ITTCOIPC9", OracleType.NVarChar).Value = dwData["ITTCOIPC9"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT9", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT9"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT9", OracleType.NVarChar).Value = dwData["ITTCOMANDANT9"].ToString(); 
          or1.Parameters.Add("ITTCOTYP9", OracleType.NVarChar).Value = dwData["ITTCOTYP9"].ToString(); 
          or1.Parameters.Add("ITTCORES1I49", OracleType.NVarChar).Value = dwData["ITTCORES1I49"].ToString(); 
          or1.Parameters.Add("ITTCORES2I49", OracleType.NVarChar).Value = dwData["ITTCORES2I49"].ToString(); 
          or1.Parameters.Add("ITTCORES1I29", OracleType.NVarChar).Value = dwData["ITTCORES1I29"].ToString(); 
          or1.Parameters.Add("ITTCORES2I29", OracleType.NVarChar).Value = dwData["ITTCORES2I29"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER9", OracleType.NVarChar).Value = dwData["ITTCOFILLER9"].ToString(); 
          or1.Parameters.Add("ITTCOBENID10", OracleType.NVarChar).Value = dwData["ITTCOBENID10"].ToString(); 
          or1.Parameters.Add("ITTCOINST10", OracleType.NVarChar).Value = dwData["ITTCOINST10"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT10", OracleType.NVarChar).Value = dwData["ITTCOSDAT10"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME10", OracleType.NVarChar).Value = dwData["ITTCOSTIME10"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT10", OracleType.NVarChar).Value = dwData["ITTCOEDAT10"].ToString(); 
          or1.Parameters.Add("ITTCOETIME10", OracleType.NVarChar).Value = dwData["ITTCOETIME10"].ToString(); 
          or1.Parameters.Add("ITTCOPID10", OracleType.NVarChar).Value = dwData["ITTCOPID10"].ToString(); 
          or1.Parameters.Add("ITTCOIPS10", OracleType.NVarChar).Value = dwData["ITTCOIPS10"].ToString(); 
          or1.Parameters.Add("ITTCOIPC10", OracleType.NVarChar).Value = dwData["ITTCOIPC10"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT10", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT10"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT10", OracleType.NVarChar).Value = dwData["ITTCOMANDANT10"].ToString(); 
          or1.Parameters.Add("ITTCOTYP10", OracleType.NVarChar).Value = dwData["ITTCOTYP10"].ToString(); 
          or1.Parameters.Add("ITTCORES1I410", OracleType.NVarChar).Value = dwData["ITTCORES1I410"].ToString(); 
          or1.Parameters.Add("ITTCORES2I410", OracleType.NVarChar).Value = dwData["ITTCORES2I410"].ToString(); 
          or1.Parameters.Add("ITTCORES1I210", OracleType.NVarChar).Value = dwData["ITTCORES1I210"].ToString(); 
          or1.Parameters.Add("ITTCORES2I210", OracleType.NVarChar).Value = dwData["ITTCORES2I210"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER10", OracleType.NVarChar).Value = dwData["ITTCOFILLER10"].ToString(); 
          or1.Parameters.Add("ITTCOBENID11", OracleType.NVarChar).Value = dwData["ITTCOBENID11"].ToString(); 
          or1.Parameters.Add("ITTCOINST11", OracleType.NVarChar).Value = dwData["ITTCOINST11"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT11", OracleType.NVarChar).Value = dwData["ITTCOSDAT11"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME11", OracleType.NVarChar).Value = dwData["ITTCOSTIME11"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT11", OracleType.NVarChar).Value = dwData["ITTCOEDAT11"].ToString(); 
          or1.Parameters.Add("ITTCOETIME11", OracleType.NVarChar).Value = dwData["ITTCOETIME11"].ToString(); 
          or1.Parameters.Add("ITTCOPID11", OracleType.NVarChar).Value = dwData["ITTCOPID11"].ToString(); 
          or1.Parameters.Add("ITTCOIPS11", OracleType.NVarChar).Value = dwData["ITTCOIPS11"].ToString(); 
          or1.Parameters.Add("ITTCOIPC11", OracleType.NVarChar).Value = dwData["ITTCOIPC11"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT11", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT11"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT11", OracleType.NVarChar).Value = dwData["ITTCOMANDANT11"].ToString(); 
          or1.Parameters.Add("ITTCOTYP11", OracleType.NVarChar).Value = dwData["ITTCOTYP11"].ToString(); 
          or1.Parameters.Add("ITTCORES1I411", OracleType.NVarChar).Value = dwData["ITTCORES1I411"].ToString(); 
          or1.Parameters.Add("ITTCORES2I411", OracleType.NVarChar).Value = dwData["ITTCORES2I411"].ToString(); 
          or1.Parameters.Add("ITTCORES1I211", OracleType.NVarChar).Value = dwData["ITTCORES1I211"].ToString(); 
          or1.Parameters.Add("ITTCORES2I211", OracleType.NVarChar).Value = dwData["ITTCORES2I211"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER11", OracleType.NVarChar).Value = dwData["ITTCOFILLER11"].ToString(); 
          or1.Parameters.Add("ITTCOBENID12", OracleType.NVarChar).Value = dwData["ITTCOBENID12"].ToString(); 
          or1.Parameters.Add("ITTCOINST12", OracleType.NVarChar).Value = dwData["ITTCOINST12"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT12", OracleType.NVarChar).Value = dwData["ITTCOSDAT12"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME12", OracleType.NVarChar).Value = dwData["ITTCOSTIME12"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT12", OracleType.NVarChar).Value = dwData["ITTCOEDAT12"].ToString(); 
          or1.Parameters.Add("ITTCOETIME12", OracleType.NVarChar).Value = dwData["ITTCOETIME12"].ToString(); 
          or1.Parameters.Add("ITTCOPID12", OracleType.NVarChar).Value = dwData["ITTCOPID12"].ToString(); 
          or1.Parameters.Add("ITTCOIPS12", OracleType.NVarChar).Value = dwData["ITTCOIPS12"].ToString(); 
          or1.Parameters.Add("ITTCOIPC12", OracleType.NVarChar).Value = dwData["ITTCOIPC12"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT12", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT12"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT12", OracleType.NVarChar).Value = dwData["ITTCOMANDANT12"].ToString(); 
          or1.Parameters.Add("ITTCOTYP12", OracleType.NVarChar).Value = dwData["ITTCOTYP12"].ToString(); 
          or1.Parameters.Add("ITTCORES1I412", OracleType.NVarChar).Value = dwData["ITTCORES1I412"].ToString(); 
          or1.Parameters.Add("ITTCORES2I412", OracleType.NVarChar).Value = dwData["ITTCORES2I412"].ToString(); 
          or1.Parameters.Add("ITTCORES1I212", OracleType.NVarChar).Value = dwData["ITTCORES1I212"].ToString(); 
          or1.Parameters.Add("ITTCORES2I212", OracleType.NVarChar).Value = dwData["ITTCORES2I212"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER12", OracleType.NVarChar).Value = dwData["ITTCOFILLER12"].ToString(); 
          or1.Parameters.Add("ITTCOBENID13", OracleType.NVarChar).Value = dwData["ITTCOBENID13"].ToString(); 
          or1.Parameters.Add("ITTCOINST13", OracleType.NVarChar).Value = dwData["ITTCOINST13"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT13", OracleType.NVarChar).Value = dwData["ITTCOSDAT13"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME13", OracleType.NVarChar).Value = dwData["ITTCOSTIME13"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT13", OracleType.NVarChar).Value = dwData["ITTCOEDAT13"].ToString(); 
          or1.Parameters.Add("ITTCOETIME13", OracleType.NVarChar).Value = dwData["ITTCOETIME13"].ToString(); 
          or1.Parameters.Add("ITTCOPID13", OracleType.NVarChar).Value = dwData["ITTCOPID13"].ToString(); 
          or1.Parameters.Add("ITTCOIPS13", OracleType.NVarChar).Value = dwData["ITTCOIPS13"].ToString(); 
          or1.Parameters.Add("ITTCOIPC13", OracleType.NVarChar).Value = dwData["ITTCOIPC13"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT13", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT13"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT13", OracleType.NVarChar).Value = dwData["ITTCOMANDANT13"].ToString(); 
          or1.Parameters.Add("ITTCOTYP13", OracleType.NVarChar).Value = dwData["ITTCOTYP13"].ToString(); 
          or1.Parameters.Add("ITTCORES1I413", OracleType.NVarChar).Value = dwData["ITTCORES1I413"].ToString(); 
          or1.Parameters.Add("ITTCORES2I413", OracleType.NVarChar).Value = dwData["ITTCORES2I413"].ToString(); 
          or1.Parameters.Add("ITTCORES1I213", OracleType.NVarChar).Value = dwData["ITTCORES1I213"].ToString(); 
          or1.Parameters.Add("ITTCORES2I213", OracleType.NVarChar).Value = dwData["ITTCORES2I213"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER13", OracleType.NVarChar).Value = dwData["ITTCOFILLER13"].ToString(); 
          or1.Parameters.Add("ITTCOBENID14", OracleType.NVarChar).Value = dwData["ITTCOBENID14"].ToString(); 
          or1.Parameters.Add("ITTCOINST14", OracleType.NVarChar).Value = dwData["ITTCOINST14"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT14", OracleType.NVarChar).Value = dwData["ITTCOSDAT14"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME14", OracleType.NVarChar).Value = dwData["ITTCOSTIME14"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT14", OracleType.NVarChar).Value = dwData["ITTCOEDAT14"].ToString(); 
          or1.Parameters.Add("ITTCOETIME14", OracleType.NVarChar).Value = dwData["ITTCOETIME14"].ToString(); 
          or1.Parameters.Add("ITTCOPID14", OracleType.NVarChar).Value = dwData["ITTCOPID14"].ToString(); 
          or1.Parameters.Add("ITTCOIPS14", OracleType.NVarChar).Value = dwData["ITTCOIPS14"].ToString(); 
          or1.Parameters.Add("ITTCOIPC14", OracleType.NVarChar).Value = dwData["ITTCOIPC14"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT14", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT14"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT14", OracleType.NVarChar).Value = dwData["ITTCOMANDANT14"].ToString(); 
          or1.Parameters.Add("ITTCOTYP14", OracleType.NVarChar).Value = dwData["ITTCOTYP14"].ToString(); 
          or1.Parameters.Add("ITTCORES1I414", OracleType.NVarChar).Value = dwData["ITTCORES1I414"].ToString(); 
          or1.Parameters.Add("ITTCORES2I414", OracleType.NVarChar).Value = dwData["ITTCORES2I414"].ToString(); 
          or1.Parameters.Add("ITTCORES1I214", OracleType.NVarChar).Value = dwData["ITTCORES1I214"].ToString(); 
          or1.Parameters.Add("ITTCORES2I214", OracleType.NVarChar).Value = dwData["ITTCORES2I214"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER14", OracleType.NVarChar).Value = dwData["ITTCOFILLER14"].ToString(); 
          or1.Parameters.Add("ITTCOBENID15", OracleType.NVarChar).Value = dwData["ITTCOBENID15"].ToString(); 
          or1.Parameters.Add("ITTCOINST15", OracleType.NVarChar).Value = dwData["ITTCOINST15"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT15", OracleType.NVarChar).Value = dwData["ITTCOSDAT15"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME15", OracleType.NVarChar).Value = dwData["ITTCOSTIME15"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT15", OracleType.NVarChar).Value = dwData["ITTCOEDAT15"].ToString(); 
          or1.Parameters.Add("ITTCOETIME15", OracleType.NVarChar).Value = dwData["ITTCOETIME15"].ToString(); 
          or1.Parameters.Add("ITTCOPID15", OracleType.NVarChar).Value = dwData["ITTCOPID15"].ToString(); 
          or1.Parameters.Add("ITTCOIPS15", OracleType.NVarChar).Value = dwData["ITTCOIPS15"].ToString(); 
          or1.Parameters.Add("ITTCOIPC15", OracleType.NVarChar).Value = dwData["ITTCOIPC15"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT15", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT15"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT15", OracleType.NVarChar).Value = dwData["ITTCOMANDANT15"].ToString(); 
          or1.Parameters.Add("ITTCOTYP15", OracleType.NVarChar).Value = dwData["ITTCOTYP15"].ToString(); 
          or1.Parameters.Add("ITTCORES1I415", OracleType.NVarChar).Value = dwData["ITTCORES1I415"].ToString(); 
          or1.Parameters.Add("ITTCORES2I415", OracleType.NVarChar).Value = dwData["ITTCORES2I415"].ToString(); 
          or1.Parameters.Add("ITTCORES1I215", OracleType.NVarChar).Value = dwData["ITTCORES1I215"].ToString(); 
          or1.Parameters.Add("ITTCORES2I215", OracleType.NVarChar).Value = dwData["ITTCORES2I215"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER15", OracleType.NVarChar).Value = dwData["ITTCOFILLER15"].ToString(); 
          or1.Parameters.Add("ITTCOBENID16", OracleType.NVarChar).Value = dwData["ITTCOBENID16"].ToString(); 
          or1.Parameters.Add("ITTCOINST16", OracleType.NVarChar).Value = dwData["ITTCOINST16"].ToString(); 
          or1.Parameters.Add("ITTCOSDAT16", OracleType.NVarChar).Value = dwData["ITTCOSDAT16"].ToString(); 
          or1.Parameters.Add("ITTCOSTIME16", OracleType.NVarChar).Value = dwData["ITTCOSTIME16"].ToString(); 
          or1.Parameters.Add("ITTCOEDAT16", OracleType.NVarChar).Value = dwData["ITTCOEDAT16"].ToString(); 
          or1.Parameters.Add("ITTCOETIME16", OracleType.NVarChar).Value = dwData["ITTCOETIME16"].ToString(); 
          or1.Parameters.Add("ITTCOPID16", OracleType.NVarChar).Value = dwData["ITTCOPID16"].ToString(); 
          or1.Parameters.Add("ITTCOIPS16", OracleType.NVarChar).Value = dwData["ITTCOIPS16"].ToString(); 
          or1.Parameters.Add("ITTCOIPC16", OracleType.NVarChar).Value = dwData["ITTCOIPC16"].ToString(); 
          or1.Parameters.Add("ITTCOLOGOUT16", OracleType.NVarChar).Value = dwData["ITTCOLOGOUT16"].ToString(); 
          or1.Parameters.Add("ITTCOMANDANT16", OracleType.NVarChar).Value = dwData["ITTCOMANDANT16"].ToString(); 
          or1.Parameters.Add("ITTCOTYP16", OracleType.NVarChar).Value = dwData["ITTCOTYP16"].ToString(); 
          or1.Parameters.Add("ITTCORES1I416", OracleType.NVarChar).Value = dwData["ITTCORES1I416"].ToString(); 
          or1.Parameters.Add("ITTCORES2I416", OracleType.NVarChar).Value = dwData["ITTCORES2I416"].ToString(); 
          or1.Parameters.Add("ITTCORES1I216", OracleType.NVarChar).Value = dwData["ITTCORES1I216"].ToString(); 
          or1.Parameters.Add("ITTCORES2I216", OracleType.NVarChar).Value = dwData["ITTCORES2I216"].ToString(); 
          or1.Parameters.Add("ITTCOFILLER16", OracleType.NVarChar).Value = dwData["ITTCOFILLER16"].ToString(); 
          or1.Parameters.Add("ITTCOUNTRY", OracleType.NVarChar).Value = dwData["ITTCOUNTRY"].ToString(); 
          or1.Parameters.Add("ITTTOWN", OracleType.NVarChar).Value = dwData["ITTTOWN"].ToString(); 
          or1.Parameters.Add("ITTPHONE", OracleType.NVarChar).Value = dwData["ITTPHONE"].ToString(); 
          or1.Parameters.Add("ITTCMDMAIL", OracleType.NVarChar).Value = dwData["ITTCMDMAIL"].ToString(); 
          or1.Parameters.Add("ITTCMDEXCEL", OracleType.NVarChar).Value = dwData["ITTCMDEXCEL"].ToString(); 
          or1.Parameters.Add("ITTMAKRBEARB", OracleType.NVarChar).Value = dwData["ITTMAKRBEARB"].ToString(); 
          or1.Parameters.Add("ITTMNRKRS", OracleType.NVarChar).Value = dwData["ITTMNRKRS"].ToString(); 
          or1.Parameters.Add("ITTMLFDNR", OracleType.NVarChar).Value = dwData["ITTMLFDNR"].ToString(); 
          or1.Parameters.Add("ITTMPOS", OracleType.NVarChar).Value = dwData["ITTMPOS"].ToString(); 
          or1.Parameters.Add("ITTDOWNDATE", OracleType.NVarChar).Value = dwData["ITTDOWNDATE"].ToString(); 
          or1.Parameters.Add("ITTDOWNTIME", OracleType.NVarChar).Value = dwData["ITTDOWNTIME"].ToString(); 
          or1.Parameters.Add("ITTFILLER", OracleType.NVarChar).Value = dwData["ITTFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
